select * from products where pro_name like '%quinceanera%bra%' or pro_des like '%quinceanera%bra%'union all select * from products where (pro_name like '%quinceanera%' or pro_des like '%quinceanera%') or(pro_name like '%bra%' or pro_des like '%bra%') and (pro_name not like '%quinceanera%bra%' or pro_des not like '%quinceanera%bra%')

Strapless Aqua Blue Quinces Gown with Ruffles and Lace-up back

Fitted Strapless Organza Quinces Dress with Appliques in Green

Orange Red and Yellow Quinces Gown with Appliques and Beading

Embroidery with Beading 15th Dress in Blue and Black Sweetheart

Orange Strapless Quince Dress with Organza Ruffles and Appliques

Organza Ruffles Sweet 15th Dress in Dark Purple with Sweetheart for Miss World Competition

Floor-length Sweet Sixteenth Dresses with Appliques in Wine Red

Olive Ball Gown Quinces Dress with Sweetheart and Appliques

Strapless Yellow Green Quinces Dress in Taffeta with Beading

Taffeta Strapless Sweet 15th Dress with Beads in Spring Green

Embroidered Quinceanera Dress for Military Ball in Coral Red

Floor-length Orange Red Sweet Fifteenth Dress with Embroidery

Aqua Blue Ball Gown Dress for Quinceanera with Floor-length

Strapless Organza Dress for 15th in Royal Blue with Appliques

Floor-length Sweet 16th Dress in Pink with Appliques in Tulle

Organza Ruffles Ball Gown Dress for Quinces in Wine Red

One Shoulder Sweet 15th Dress in Multi-Color with Ruffles

Spring Green and White Quinceanera Gown with Embroidery

Yellow Green Beaded Dress for Quince with Organza Ruffles

Strapless Sweet 15th Dress in Green and Hot Pink with Beads

Hot Pink Organza Ruffles Quinceanera Dress with Embroidery

Floor-length Purple Quinceanera Dresses with Embroidery

Appliqued and Beaded Quinceanera Dress in Gold and Yellow

Embroidery with Beading Sweet 16th Dress in Green with Straps Nicki Minajs evening dress

Strapless Quinceanera Gown with Pick-ups in Teal with Taffeta

Strapless Baby Blue Quince Dress with Floor-length in Organza

Dainty Appliques and Pick-ups Decorate 2013 Dark Purple 15 Gown

Exclusive Purple with Zebra Print 2013 Quinceanera Dress Sale

Gorgeous Strapless Ruffled and Beaded Red Quinceanera Ball Gown

Multi-color Unique 15 Gown Banded with Fishbones Layered 2013